import openpyxl
wb = openpyxl.load_workbook('example.xlsx')
sheet = wb['Sheet1']
#print(type(tuple(sheet['A1':'C6'])))
#print(tuple(sheet['A1':'C6']))

for rowOfCellObj in sheet['A1':'C6']:
    for cellObj in rowOfCellObj:
        print(cellObj.coordinate, cellObj.value)
    print('---End Of Row---')
print('\n')


sheet2 = wb.active #Deprecated: sheet2 = wb.get_active_sheet()
#print(sheet2.columns)
for cellObj in sheet2['b']:
    print(cellObj.value)
